SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[_Stock_GetItems] @DrugId NVARCHAR(20)
AS 
    BEGIN
        SELECT  *
        FROM    dbo.Stock
        WHERE   DrugId = @DrugId
        ORDER BY ExpDate
    END
GO
